<?php

namespace App\Controller\Example;

class UserExample extends BaseExample
{
    /**
     * 数据库实例
     * */
    public $id;// int(11) NOT NULL AUTO_INCREMENT,
    //public $token;// varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    public $openid;// varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '微信openid',
    public $username;// varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号',
    public $truename;// varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '真实姓名',
    public $password;// varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码',
    public $pay_password;// varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '支付密码',
    public $phone;// char(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
    public $head;// varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
    public $pid;// int(11) NOT NULL DEFAULT '1' COMMENT '推荐人id',
    public $agent;// int(11) NOT NULL DEFAULT '0',
    public $level;// int(11) NOT NULL DEFAULT '0',
    public $level_time;// datetime DEFAULT CURRENT_TIMESTAMP COMMENT '开通时间',
    public $group;// int(11) NOT NULL DEFAULT '10' COMMENT '用户组 10:客户',
    public $money;// decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '用户余额CNY',
    public $usdt;// decimal(15,6) NOT NULL DEFAULT '0.000000' COMMENT 'Usdt',
    public $myr;// decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'myr(马来西亚币)',
    public $capping;// int(10) NOT NULL DEFAULT '0' COMMENT '封顶值',
    public $id_card;// varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    public $svip;// int(11) NOT NULL DEFAULT '0' COMMENT '0 注册会员 1经销商会员',
    public $login_ip;// varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '登录ip',
    public $create_time;// datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    public $last_time;// datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次登录时间',
    public $status;// int(11) NOT NULL DEFAULT '1' COMMENT '状态 1,正常 0,冻结登录',
    public $ach;// decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '自己业绩',
    public $one_ach;// decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '单次业绩',
    public $sach;// decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '旗下累计业绩',
    public $share_rewards;// decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '已发小区奖励总计',
    public $push_reward;// decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '分红池奖励（每周静态）',
    public $peer_reward;// decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '动态奖励(大区)',
    public $agent_reward;// decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '抽奖奖励',
    public $total_reward;// decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '累计奖励',
    public $collect;// decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '今日领取奖励',
    public $is_white;// int(1) NOT NULL DEFAULT '1' COMMENT '交易白名单 0不是 1是',
    public $is_trade;// int(1) NOT NULL DEFAULT '1' COMMENT '交易冻结 0冻结 1不冻结',
    public $is_get;// int(1) NOT NULL DEFAULT '0' COMMENT '冻结领取 0冻结 1不冻结',
    public $caigou;// decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '本季采购金额cny'
}